Draftworx Wiki

Appearance

Working Trial Balance Basic Functionality (Cloud) ​

What it is: The central workspace in Draftworx Cloud where imported trial balance data is viewed, managed, and prepared for linking to the financial statement template.

What it's for ​

The Working Trial Balance (WTB) is where an accountant spends most of their data-preparation time. It shows all imported account balances, their links to the financial statement template, adjustments from journals, transactions from the cashbook, and various period views. From here you can navigate to prior years, add entries manually, export data, and keep prior-year figures in sync when changes are made retrospectively.

How to do it ​

Inside a client engagement, open the Financial Data dropdown and select Working Trial Balance. The current tax year is displayed by default.

Adding prior tax years ​

Click Add Prior to add a comparative year (up to four prior years). Having at least three years of data significantly improves automation for cashflows and reconciliation notes.

Manually adding an account entry ​

In the green input bar at the top of the grid, type the Account Number and Account Name, click the blue Link Account icon to assign a link number, then press Enter. The new row appears in the trial balance.

Exporting to Excel ​

Click Export > Export to Excel to download the full trial balance as an .xlsx file.

Drilling down on direct-import amounts ​

For accounts imported via Sage, Xero, or QuickBooks, hover over an amount until it turns blue, then Ctrl+click (or right-click and choose Drill Down) to view the underlying general ledger transactions. The drill-down can be exported to Excel.

Changing the period view ​

The Periods button lets you switch between multiple views, including monthly trial balance, monthly transactions (cashbook), monthly adjustments (journals), yearly finals, interim amounts, and differences between years.

Resyncing the prior year after retrospective changes ​

If a journal is processed in a prior-year engagement after the current year has been rolled forward, click Resync Prior Year on the current year's WTB to pull through the updated prior-year figures without redoing current-year journals. Note that any manual AFS changes will need to be redone separately.

Applying disclosure updates ​

When reporting standards change and Draftworx releases template updates, click Disclosure Update to apply pending updates to an older engagement file. A backup is created automatically at the moment you confirm and apply the update (not when the dialog first opens), so the pre-update file can be restored if needed.

Click Add Links to expand the set of links available in the template (e.g. if a client has more bank accounts than the default template provides). Filter by keyword, select the required option, and confirm. A backup is created automatically.

Source ​

https://draftworx.helpjuice.com/en_US/cloud/draftworx-cloud-working-trial-basic-functionality

Walkthrough ​